Exploring Load Balancing in Parallel Processing of Recursive Queries
نویسندگان
چکیده
Recent work on load balancing has connrmed its importance when one wants to achieve good performances during the actual evaluation of parallel database queries. Existing work mostly focuses on the join processing for parallel relational databases. We are interested here in more complex queries, such as recursive ones. The main diierence is that, in the latter case, the work due to a task cannot be previously determined and, consequently, no method can deene at the outset the tasks to be executed in parallel in order to balance the workload at each processor. We propose a dose-driven dynamic strategy that aims at obtaining an improved workload balance and better use of the available resources. We examine the applicability of our strategy with its specialization to the case of the transitive closure query. Preliminary computational results on randomly generated test problems illustrate the eeciency of the proposed method.
منابع مشابه
Parallel Computation of Linear Recursive Queries in Knowledge-Based Systems
Parallel processing of recursive queries in KB systems is an important means to improve performance. However, two significant problems: heavy interprocessor communication and poor load balancing, are inherent features of query answering methods based on Least Fixed Point computation, such as Naive and Semi-Naive. They make it difficult to ensure efficiency for all distributions of data values. ...
متن کاملExploring Load Balancing in ParallelProcessing of
We study a dose-driven dynamic load balancing strategy to evaluate database recursive queries. This proposal aims at obtaining a good workload balance with full use of the available resources, with different kinds of skew considered. The strategy is intended for general recursive queries and preliminary computational results illustrate its ef-ciency when applied to the particular case of linear...
متن کاملParleda: a Library for Parallel Processing in Computational Geometry Applications
ParLeda is a software library that provides the basic primitives needed for parallel implementation of computational geometry applications. It can also be used in implementing a parallel application that uses geometric data structures. The parallel model that we use is based on a new heterogeneous parallel model named HBSP, which is based on BSP and is introduced here. ParLeda uses two main lib...
متن کاملA Communications-oriented Methodology for Load Balancing in Parallel Relational Query Processing
The increasing amount of data manipulated in very large databases 1 and the complexity of the queries to be processed makes parallelism appear as one of the most promising research axes for future databases applications. Load balancing for relational operators has been widely studied and join algorithms including dynamic load balancing capabilities have been proposed 1]. However, for whole rela...
متن کاملAnalysis of Dynamic Load Balancing Strategies for Parallel Shared Nothing Database Systems
Parallel database systems have to support both inter-transaction as well as intra-transaction parallelism. Inter-transaction parallelism (multi-user mode) is required to achieve high throughput, in particular for OLTP transactions, and sufficient cost-effectiveness. Intra-transaction parallelism is a prerequisite for reducing the response time of complex and data-intensive transactions (queries...
متن کامل